Open topic with navigation

(continued from Colours)

Dates/Times

All date fields in Tourplan are able to have times stored in them, but the times are not always displayed on screen and in some instances times are displayed as separate fields. It is possible to use INI switches to format how Dates and Times display. Before adjusting date/time formats, there are some issues that should be considered. First, the INI switch display settings are system wide, so whilst it may be nice to have for example, Booking service dates displaying full Month/Year, it may not be so practical when in Debtors Transactions. Remember there is an actual screen limitation as to how much can be displayed. Second, the INI System settings for date time can be overridden in messaging by using the message code <DATEFORMAT:( parameters)> to get specific date/time formatting into specific messages. If a date/time format is incorrect and not recognised, then a TourplaniS default setting will be used.

.Net (the language TourplaniS is written in) does not always recognise the “standard” Windows date/time settings, but in general, the use of the same codes is supported—e.g.

• d = Numeric Date—e.g. 15
• dddd = Alpha Day

(note–to obtain Alpha Day and Numeric date, a combination of the codes must be used—e.g. dddd-d)

• mm = Numeric Month—e.g., 05
• mmmm = Alpha Month—e.g. May
• yy = 2 digit year—e.g. 03
• yyyy = 4 digit year—e.g. 2003
• hh = Hours (12 hour format)
• HH = Hours (24 hour format)
• nn = Minutes
• ss = Seconds

The following are the values which will be used if the INI file data is unrecognised:

DATETIME_FORMAT_DISPLAY = dd-mm-yyyy hh:nn:ss

DATETIME_SQLFORMAT = yyyy-mm-dd hh:nn:ss

DATE_FORMAT_ENTRY. Valid choices for this setting are:

dd mm yy, dd mmm yy, dd mm yyyy, dd mmm yyyy, dd/mm/yy, dd/mmm/yy, dd/mm/yyyy, dd/mmm/yyyy, dd.mm.yy, dd.mmm.yy, dd.mm.yyyy, dd.mmm.yyyy, dd-mm-yy, dd-mmm-yy, dd-mm-yyyy, dd-mmm-yyyy, d mmmm yyyy, dd mmmm yyy, d mmmm yy, dd mmmm yyyy

If unrecognised, dd/mm/yy will be used.

(continued in Database)

Open topic with navigation